SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411369 LIMIT 1 [ RunTime:0.001184s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411369 [ RunTime:0.004461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005452,344843,622012,56058,875525,50646,642146,403155,579199,230168,65913,797070,318509,735083,52974,963824,321528,182303,334094,653570,261455,1005685,86587,531140,83540,909329,1013452,638508,1003294,759757,261283,839324,816399,110857,663534,538520,490660,335166,238866,285337,385427,765256,734509,519333,83179,899640,603725,15020,560189,706303,1042916,1000913,601748,484211,443413,816810,36017,970086,625852,848116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411369 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411369 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]