SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511476 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511476 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736239,153548,420230,569190,898880,637115,666759,85501,206142,1009176,1030150,180679,948102,1014112,477982,721828,229464,28978,761445,432152,55392,571009,797491,205623,182496,5084,981770,374464,40100,930960,622221,290946,101922,533698,771735,982720,348149,253234,924295,243195,131970,137837,65996,675707,512745,479166,841796,819219,116020,889769,925405,850632,822243,135348,27289,624325,877226,243712,435391,104803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001203s ]