SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 370840 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 370840 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43959,325166,350797,168778,215105,217198,624984,204001,162471,625040,140630,103392,201801,371617,721090,292664,58536,175925,156559,334071,935247,458149,499556,740547,211913,926519,968941,754950,661928,87295,532069,295268,227535,727656,153029,984660,369097,229908,314938,591165,799881,20110,87270,736436,1021611,262881,700003,831340,984605,636113,209443,1009833,730692,9427,955535,151138,740746,828684,529435,788375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 370840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 370840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]