SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105099 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105099 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98487,706963,730961,451368,486100,677543,640876,504535,547604,107971,41361,295968,354532,589002,349827,441052,636433,567150,836720,906166,596017,898511,172943,310684,39848,580033,539561,92387,1009016,869724,670738,355541,260329,1013567,955051,1044976,895228,920214,285500,105243,370320,259914,408086,343662,443581,172116,118020,31133,194512,750355,253699,102430,101808,689839,523075,399706,978418,276884,32667,849460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]