SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317896 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317896 [ RunTime:0.002288s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803951,645449,601637,1019770,899943,551295,988005,460321,219685,338016,723788,969245,293455,807966,299251,230499,599539,191451,757176,888461,828664,435653,466450,1048829,969278,564950,1028508,992183,118866,996508,1001977,236789,316453,973448,437013,243075,975558,383244,145339,349101,866164,120866,957756,939294,333591,934560,788724,187672,563071,607488,568003,227672,711174,918133,839056,575159,622939,226547,283971,196101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]