SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802378 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802378 [ RunTime:0.002931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605813,66738,366246,605384,1016936,21914,158521,187581,157241,603968,34307,210678,915371,651084,896884,242483,783178,233342,289982,137415,520938,29164,118995,738778,742822,774315,533734,148617,1006195,327070,410573,970769,534114,512040,742793,179928,996836,871574,320930,747366,1012669,86814,832223,1036283,353110,814158,331354,988910,717195,744834,339473,169628,527475,581696,578646,100640,24639,769809,9636,711594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]