SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436499 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436499 [ RunTime:0.003577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407653,49047,256071,536688,148305,199333,506143,1036229,620520,798427,662613,37136,893292,887187,961718,133933,116042,476078,807069,556493,131334,85571,128338,781047,619825,556536,726709,1029106,1020888,355101,657806,344836,319226,534788,747789,246760,1026102,570494,734637,211382,809577,179122,46474,449204,594647,150048,414576,925009,229602,239230,726273,386350,479856,940790,634935,352436,542415,951692,68197,162784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]