SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484221 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484221 [ RunTime:0.002843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537630,692666,141503,365372,1025681,995759,130312,959075,771969,1017468,1044115,624534,519769,573899,1019166,33411,632411,14137,208219,570076,1014532,1014483,275576,367902,633197,721049,641847,741222,913071,417568,56442,434915,416151,239452,340303,113248,239563,333087,607382,760769,357554,938141,272622,362572,787156,843158,272282,916532,467018,976186,1045349,167531,797717,949233,613473,223816,171244,815637,521904,737395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002916s ]