SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98104 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98104 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322428,959889,180689,961605,175671,87275,1032072,963127,437824,682331,217229,816503,315315,564883,849116,231350,868306,562187,997809,979257,589911,1020545,742876,737871,732763,900682,395216,167942,660020,344318,404952,808542,1039762,139687,634230,720652,538808,474301,521191,619713,875497,1036564,253506,70674,964329,534590,35475,502906,380929,351685,228328,626220,979409,124451,43689,191652,257559,885753,613030,489714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]