SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447844 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447844 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198505,341771,964391,479068,16194,520257,351058,812903,693241,981967,926940,614724,866312,568512,604569,31388,72012,875185,8640,805536,468975,826281,392573,789612,478038,448096,495548,92058,874470,821515,26023,1041718,395805,489799,485998,203275,469534,108263,719647,682299,1003586,175562,960794,901382,463867,932738,189844,133623,254028,788014,378238,850158,917848,829081,520235,421209,973424,759888,685668,208073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]