SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006446 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006446 [ RunTime:0.003971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412525,720571,615922,541878,212096,586775,763180,254867,152564,719569,179761,526061,634714,649391,927013,468562,136516,615975,431987,106590,1016817,1990,909635,45246,196799,927926,481891,821485,604279,95132,529683,953506,951001,259326,631664,264051,720154,624253,334845,846691,174651,959499,123992,661036,101143,685988,636342,933787,759579,180218,126223,597484,133305,184350,923733,2,625856,776444,929940,112730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006446 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006446 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000953s ]