SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40158 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40158 [ RunTime:0.006914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226102,993985,1010024,870010,829042,667392,698549,411328,46874,286206,347492,25596,440404,881624,307393,939598,336634,184208,505397,277235,382989,451887,661166,502359,39680,513663,376352,332054,810633,1043594,429466,92346,771126,669017,334667,691541,595094,725051,1002544,271411,915526,152296,305322,234852,234769,725970,622961,653422,13726,687965,289247,874080,396965,45448,844860,878773,1035547,994914,241004,325193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]