SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434653 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434653 [ RunTime:0.001489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538463,963107,991149,98505,478796,313618,787439,377320,232203,511576,543040,793430,899304,1041327,593306,60980,971414,559155,699351,1045042,737817,152791,80166,960657,9380,997857,573587,499329,791157,624349,203748,987799,951747,958588,995893,548683,990540,239341,370928,504140,715414,1037801,424466,969384,780921,781168,287986,93715,436991,420224,789687,935189,442400,194051,450141,158905,73509,577284,931648,224011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]