SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333545 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333545 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251893,806536,779299,1048415,516893,541942,735384,417783,786637,254710,564436,694022,369457,21305,395183,697328,220850,277167,685667,67303,709097,683231,53900,78232,1014997,288401,474541,903877,77040,747834,161475,1048795,741047,133250,154630,775675,454228,245359,213650,953885,154549,40246,937660,836057,82394,933298,177766,387180,771498,743370,470961,457174,471183,1006163,499461,92887,790313,115724,992644,39950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]