SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504546 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504546 [ RunTime:0.002826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984009,439952,911039,603511,509273,785239,904357,827478,230412,552849,269412,628718,659000,451250,866272,526817,521745,46421,144321,950897,887545,90665,899988,139674,344796,178144,160090,314470,721081,582050,537809,232453,417224,615480,1019019,464017,737036,857137,825925,38248,129263,556205,372336,588009,189255,780173,486037,759226,243769,983142,687697,789915,477677,145573,444776,578000,874442,338887,837057,836771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]