SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014713 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014713 [ RunTime:0.002126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234501,298292,227773,919726,969867,934318,381183,779641,244331,833545,652039,463097,997248,746911,598258,200558,553747,429357,657147,851670,102077,443729,709508,435139,416606,642195,979789,797849,7438,219035,781776,67757,457397,214564,559414,687243,285976,252582,218607,980890,320739,410690,45534,309234,166197,202473,786904,59477,846214,39825,387157,640986,412605,885410,263667,222565,524352,629513,277015,661410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]