SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538946 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538946 [ RunTime:0.002104s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269951,970919,287011,752000,547671,289397,861912,860097,814813,543696,714886,1035772,84212,667802,9415,760852,585860,969588,1027926,108127,894243,954588,643850,991383,313172,643442,407068,82328,929095,376228,1018274,875704,573522,774223,543698,1037346,213757,145634,61785,85865,775231,1028531,494340,127379,14848,271877,711207,43146,601516,171132,420494,351429,459352,998899,394522,939387,206136,112371,571784,622339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]