SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565076 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565076 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724692,308565,552315,280107,932380,732173,387499,54507,101314,867193,1025584,1014538,276942,511196,908667,330761,85541,172960,1012755,474876,121645,715578,210995,568684,715714,239090,153324,906428,728872,1004334,288954,687978,1016702,746749,600630,171735,804412,650928,228550,177579,134774,168219,826851,195735,884036,529801,601805,43641,31668,304173,981401,246170,660426,840508,415203,730170,1012113,514916,140386,876656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]