SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015037 LIMIT 1 [ RunTime:0.000638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015037 [ RunTime:0.003238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384057,673254,80610,1033096,591965,520836,437162,557613,10754,661662,906903,75232,814813,385650,169608,183639,964630,1038222,446665,231532,633077,776378,183993,180468,548498,1017066,1007754,829112,988789,634171,156453,414519,220794,981186,911437,85443,961152,808714,731388,406567,667163,196182,863483,224045,939033,337877,895738,856295,757469,906917,588177,337270,476826,363134,578075,275849,357449,680953,879458,142989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001619s ]