SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971643 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971643 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500728,465732,700376,822681,525733,100603,509086,330545,758219,486389,442166,805373,834584,548291,189551,743123,636579,57864,193142,872196,1023394,996024,634371,638930,852163,398632,288541,126546,845099,780408,13613,654253,661449,352928,409683,173698,629503,250689,166690,1040201,483786,756875,884424,492088,396100,643383,644482,485562,877491,870794,674592,655020,272974,23812,632251,800673,130768,910504,727130,1046932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]