SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403664 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403664 [ RunTime:0.004083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343376,266967,201671,105456,279129,79605,713468,509688,924452,478118,811828,119219,770547,49047,503027,699957,96482,187816,924922,1013760,958628,10356,775626,939008,1000510,594168,759364,788698,595855,2002,854739,480658,655563,1042099,597369,731904,107228,527654,624006,807138,567363,994595,1014985,225865,92808,931716,584890,1032986,303207,543802,410506,1015953,374786,537012,133815,604349,770813,696047,636971,640773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403664 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403664 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]