SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111197 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111197 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541307,405701,442154,203081,178400,478822,156845,979401,740358,313354,544086,433286,649497,412353,302274,25518,974283,1033403,826901,102360,1044601,989968,217248,820907,245044,434722,333826,1004802,565474,473664,234100,144285,937828,973209,1010624,257265,13482,134497,510018,470928,540714,1045547,977471,308808,800381,23034,673060,977750,321197,758993,556188,947875,622692,642056,713610,904626,836050,901686,324871,446325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]