SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318508 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318508 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734690,49108,728326,361912,984475,571314,139172,94442,656443,658331,53053,525112,367336,448553,133098,464914,935082,995851,742806,999793,412742,91790,490764,501009,816110,651528,98285,97818,542717,232143,93579,409832,207504,1038696,573015,950271,505619,425750,206842,690985,30338,962798,233482,780711,825862,121472,982469,993283,364305,589244,447458,520228,909368,276553,175604,98334,709321,598672,840929,659577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]