SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001114 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001114 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219374,201097,554030,109781,682349,273049,468367,302799,460678,611709,1026419,128461,420224,102551,87735,211234,168373,327198,111961,648475,543603,230985,800416,260344,757,6839,244230,429719,624468,750275,693607,580048,733234,644972,120807,1028784,10143,154689,652952,274161,986545,737647,191941,928352,347460,164279,313148,803796,226459,679489,941805,406014,389536,608179,62232,211595,329537,531692,761810,954055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]