SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194097 LIMIT 1 [ RunTime:0.000683s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194097 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949024,92007,263186,449889,348505,1021258,438006,526141,421238,88400,183952,1017426,369040,927914,709347,743034,277464,496519,515127,385775,653928,368698,296845,998910,407804,455037,550310,34967,778225,456425,869748,553864,103215,928935,968846,993881,892015,455127,467635,641075,866602,884456,701869,500694,286690,105261,160286,700766,398065,935822,614770,240503,439370,305609,684752,644366,889906,37838,206293,338857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]