SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008576 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008576 [ RunTime:0.002874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242661,349441,589613,942727,637737,381836,697560,738174,11329,560462,585181,568148,565927,825594,7020,664687,980322,1034246,102243,788216,486772,407577,935055,48714,1021193,496481,446547,852075,1000957,285647,384275,131829,611832,933660,72731,657345,844798,677058,779713,707657,439352,642760,594796,1037081,595488,503063,850363,747736,15938,551633,399872,195503,83057,753749,292899,398138,129926,475695,896455,106560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001724s ]