SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299474 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299474 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527662,9389,608034,514059,582824,928253,224462,669228,405902,903918,2457,426880,531283,206,813628,791799,649037,374743,567705,592536,115804,842679,583244,851350,603886,782133,2734,812802,351600,718686,664675,477747,826901,792919,678855,169995,502936,736775,987135,449567,585188,278616,851538,196800,570613,351797,426120,305044,539911,736879,887400,905270,827676,786140,56658,418400,248704,868137,659411,31824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]