SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343601 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343601 [ RunTime:0.001382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254789,408168,569069,123107,536165,548922,385778,106582,823875,321420,111601,873327,1015875,611069,608332,530854,731001,482281,350896,1036216,374485,538240,292528,953908,232291,646951,413940,433053,977753,654568,553304,513852,390974,839296,857503,622110,200528,738808,332070,539530,983737,985612,832842,891573,698568,834857,480326,982594,104117,739498,53687,434681,691138,410968,239117,468257,488499,853229,105977,846999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]