SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001777s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512615 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512615 [ RunTime:0.003270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109022,585013,820424,481991,1107,125261,218189,332987,650349,340507,498295,828442,159047,380383,270916,140269,1029304,114684,477087,74321,197623,398721,707265,380187,958466,341028,830974,261436,415946,914432,993678,461167,28023,344933,498560,1011413,555122,788147,715085,383343,789680,986740,435847,219395,814888,412178,938353,85873,250148,26345,187208,349425,291943,1038000,631050,555219,480430,950352,12599,338178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]