SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803713 LIMIT 1 [ RunTime:0.002027s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803713 [ RunTime:0.005385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757457,351182,446015,475421,856553,1020646,929935,553155,319289,810005,23330,879807,795397,104777,168984,601617,56143,1033571,489369,85710,590445,585525,521137,815026,295261,285953,903271,484634,274306,304686,128575,564482,963014,945132,238411,109975,353659,229385,513175,354092,894258,983778,615799,800761,449258,543752,357806,667737,769959,390125,1025319,543043,217179,356467,877563,354412,829840,280080,508217,409294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]