SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385098 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385098 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273157,630077,118860,65846,75070,623928,723668,178211,814024,1027506,827135,591454,1009469,575917,945734,484804,104194,697725,289380,570360,314448,54772,409811,703856,16607,28400,650584,172673,938469,211892,968205,1037808,715896,370335,566098,898147,648170,40562,729569,175469,305972,8122,896236,1048605,632984,385122,70282,105676,275353,307286,956559,798118,1008772,182227,830804,1014318,996418,129679,153093,20229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]