SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526094 LIMIT 1 [ RunTime:0.002115s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526094 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908996,197950,481520,1017444,218618,208924,525869,818927,216538,432131,464922,143114,910315,1026758,1016991,681311,681612,431148,459077,463991,570513,157883,866163,310549,470543,728604,779359,698029,205519,316621,487169,453855,386122,450802,191564,292359,79715,389592,163363,15524,283243,339155,385670,350805,459521,575669,837930,496672,994409,55663,311843,1023723,292956,287825,701409,950322,309793,317539,849640,759602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]