SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100210 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100210 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110738,200944,775491,481371,923324,633467,220335,731044,910406,994609,602483,572196,525511,153143,835475,1002351,511034,66724,916061,287742,333813,719391,77923,739587,674434,933713,1021170,276354,707219,427913,554407,383400,706261,655308,759110,639657,292697,721322,638133,584014,659331,771643,749650,493045,475295,695461,95790,4951,460706,829029,4334,903584,287675,362205,647932,790441,678873,336767,918630,223386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]