SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047954 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047954 [ RunTime:0.002452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249109,215881,364526,444511,403862,341722,339713,278603,720609,1010665,849781,1042948,227131,848360,112504,334507,667861,949238,239981,570905,751982,102956,618079,362488,265844,543986,1030162,498419,259079,289638,563931,537752,229496,893991,118142,951606,325750,789383,208629,804889,98555,15712,104301,512799,918048,702430,485357,229248,528623,514181,349869,560732,872476,611544,136997,395017,781038,75864,226126,701103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]