SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038106 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038106 [ RunTime:0.005586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027828,291424,750670,9824,724083,353436,61114,170908,721114,75718,789920,567451,171462,811428,435385,45330,489073,674264,729951,152686,60135,572697,948373,940174,952892,765921,224611,81745,195024,129052,242035,567241,187724,821240,92472,135819,962965,426635,582349,877460,546714,906564,959106,615533,876976,419069,1046356,125557,186700,479237,134668,438591,537226,953732,680008,897330,1048630,882081,379768,304017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001339s ]