SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104834 LIMIT 1 [ RunTime:0.001792s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104834 [ RunTime:0.003417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599995,963979,941193,348821,694251,499939,754744,360055,743140,633502,382709,540934,943278,44188,1018907,473488,465633,813356,176057,453587,741135,272077,972236,290735,779152,185836,439122,307599,868942,807806,485715,538636,737017,763986,364442,807826,806811,9038,381955,103049,355269,536079,475147,187761,488009,313086,2870,1010019,257600,252985,841501,591773,178621,510513,642258,816455,317599,92567,524516,1046240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]