SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504833 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504833 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886815,121402,587838,458039,385547,1041538,489903,487330,625242,859767,833406,914208,286877,22658,638032,688465,199602,950544,438848,364006,135393,826747,29063,185929,650832,516153,285942,672133,185879,667882,536585,949417,1010131,897527,1034035,580875,1035616,721478,796180,253066,1015587,217483,1019747,413999,370916,338107,146289,771035,136604,196613,964255,53450,580816,170921,905378,879412,507123,985235,881794,95163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]