SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806008 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806008 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681931,260678,804645,690754,937799,404624,415929,200679,416226,270102,426364,671318,502914,176028,790798,543085,967667,310318,334806,385089,14559,862870,352659,712329,813997,331502,427176,727239,983172,202669,337980,355298,221606,588615,404086,526572,499,413619,585551,69285,386275,310559,485867,1037922,137684,275531,438013,401436,1009281,903916,447030,1016009,329334,853763,637917,498173,475444,179625,901217,1034081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004185s ]