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` = 465918 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465918 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406153,512512,321309,918690,702741,160116,361320,834979,811531,867969,141989,620667,1018052,23570,538043,845270,470762,646273,965736,882653,113438,394214,344688,211136,530893,314512,287086,859252,783858,863312,274549,29106,107939,701812,977104,911851,170094,40484,87129,823145,597125,684851,510326,890398,131289,719137,270980,325267,750686,755668,1004700,332910,485713,214090,260854,873736,512705,176956,563415,144598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002382s ]