SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040206 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040206 [ RunTime:0.001437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30554,276908,507458,187878,434536,950528,51400,311631,676250,852876,625504,803436,500050,979847,908777,276872,265395,237086,509761,125967,970121,289791,615361,81261,106599,93678,562042,370653,411745,104580,502293,883529,484360,470960,877759,812225,548249,447706,110279,475655,513931,449097,98365,9987,485612,392513,974362,123035,784724,741742,430941,757205,403245,117779,680013,823881,919353,767554,307476,805955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]