SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394413 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394413 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948972,1036314,52605,841179,875125,72475,314714,684730,782228,832813,879115,519349,159473,967372,419878,542671,108572,206019,881792,47951,990936,128341,467931,982127,652814,782914,844078,395014,261095,568878,274156,720376,574342,860495,936306,546420,555882,247535,4068,508075,160353,581587,368325,293092,282156,76367,505915,377471,965291,281718,686200,19414,552372,66029,223365,859428,165915,115776,353802,587854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]