SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34660 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34660 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145583,35988,180746,416563,733386,322159,839064,605133,267950,778055,456939,1004249,363614,306650,278324,780822,553180,533394,999110,96553,86991,444664,326354,358738,376610,343994,283090,311043,953091,279329,765673,390789,259636,888231,495698,113529,633087,318059,430096,190031,729651,508009,734074,926203,540192,556115,1024427,704518,416013,466742,222115,606029,224220,699004,886290,705255,734450,473256,43185,108664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]