SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436398 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436398 [ RunTime:0.003028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34648,296600,466938,334864,724504,736794,382913,109192,32131,643196,104181,1021455,186257,422515,27567,531116,915778,411173,545080,429839,245178,39583,704332,240617,126811,311628,966949,696840,18435,239995,180305,573366,947392,92939,708090,104387,1033591,269017,49758,896998,957036,483573,629900,103519,687352,431324,198771,309926,503304,987205,685176,21221,671875,269992,513955,580832,887844,564093,947009,428748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]