SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910800 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910800 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555076,639163,845175,241481,313567,537064,428307,921867,55132,194083,6811,176494,587870,942383,565994,667568,228680,774281,300661,66278,693740,850722,424995,170849,612999,542834,690159,268150,138935,156363,180789,415820,298021,98377,960315,629290,781717,219204,790604,796963,666861,957533,538350,958076,886844,827178,725287,874887,113629,433847,642303,566966,611538,52424,779436,709833,759409,395873,571126,412383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]