SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038411 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038411 [ RunTime:0.003336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625524,417291,1045022,667240,996829,423900,855536,865144,475318,133586,615523,680137,411835,516993,331658,390152,657437,858105,795631,351793,619989,364692,795777,236139,652436,873846,620801,337429,191827,536033,597017,722684,561382,1036156,18798,779675,979053,887533,472257,377008,249622,322235,808865,700335,784604,574643,820057,36038,685224,309446,290962,615210,511354,534685,678657,556637,370758,886582,907365,988767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001827s ]