SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450498 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450498 [ RunTime:0.004598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292180,67211,500062,351385,1014964,446402,399069,678150,988517,648741,796942,1008454,611883,828748,554330,366271,40765,118379,198557,152817,1038217,825109,1044938,672132,1026528,316611,254549,791742,786936,462901,173792,1361,668493,601925,549040,1041874,576864,212898,560518,367999,660578,664220,297734,773905,408385,178629,523251,684085,293773,806280,776360,617728,239233,720099,277170,498661,589545,453044,744913,187639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001488s ]