SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41423 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41423 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615126,300438,1006957,937292,431191,451639,236709,427313,348218,282910,645687,448835,478938,624445,479993,880204,636579,10539,449360,331571,746460,203940,431749,258130,531712,725444,4197,700647,638622,83846,533341,229712,226543,827225,718761,224762,584024,270638,204664,908062,451814,538824,961224,562839,355030,703874,778123,3800,498805,760735,627957,99474,734450,715438,639267,302048,678361,619478,581965,660739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]