SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4363 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4363 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001885,709742,72346,473967,104632,1037377,759714,255669,392661,194303,636387,591117,901486,243982,931286,988507,811760,224600,303530,736954,891550,746811,125941,531999,903744,612531,495024,737825,712200,300662,221842,770123,594965,419541,1045950,452623,38135,29129,221132,454228,958677,397233,1047831,118738,857148,213549,837021,56272,217042,176926,209595,840321,202564,967206,796995,50007,150872,150285,207647,615768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4363 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4363 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001033s ]