SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007290 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007290 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (143829,470726,35533,703722,699857,919321,322253,471551,911568,1009593,772240,612584,100302,41312,723523,452351,291513,661861,745642,507302,934356,1023395,631154,223313,906709,905810,869695,641810,387434,367333,845305,701258,461044,690250,134248,53001,134390,1040061,221354,167085,521393,704404,222295,474671,572188,197083,1035251,48799,173115,504627,936742,178830,698320,554345,298075,993281,403037,636196,865114,915443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007290 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007290 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]