SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260327 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260327 [ RunTime:0.002063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71105,636084,316486,569023,1027199,738507,33893,929250,984658,159807,732628,409973,592944,919273,977803,172563,148497,891373,63281,950490,127239,495677,614439,983385,510567,969121,367547,737577,585508,252855,719894,715363,719937,599325,807785,510546,922020,866203,343939,460139,102717,729397,567895,458081,311814,989671,933121,989317,901554,818472,861889,968595,556452,416832,31263,586318,116827,534407,677071,198158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]