SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4225 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4225 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413058,9906,663573,902937,506542,720034,358243,437322,670544,236143,438061,267598,56194,837462,70743,141556,758441,602808,741836,606053,290733,6289,749118,772762,64045,327464,645270,42136,332202,932549,361242,191542,251611,409167,299803,437368,49759,798800,366907,769061,876396,1044475,431868,316183,314216,143331,634260,991744,783514,682326,813902,352282,936454,220415,200020,533847,307383,327057,432691,480728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4225 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4225 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]