SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327306 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327306 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300943,1020483,231244,260288,317385,792009,391449,751955,740291,386434,1019578,459503,375504,189506,345087,912928,209727,263235,293933,287475,15747,1005658,300618,917306,804642,542257,817199,306947,983088,772528,415941,1046532,685759,414609,1022255,524955,541491,244155,921241,865372,122533,140190,341159,736222,1022765,833757,445556,1048289,287804,561779,32159,15019,349162,643824,559096,1037544,888114,297740,530930,734193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]