SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561210 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561210 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454149,23028,352041,554372,768720,989134,916913,613807,623339,1234,599594,356067,266671,674040,400852,13707,649068,580578,25459,899930,135458,534785,785831,197501,346573,372604,858543,889681,418399,83188,693570,956606,303720,294484,988519,304018,96021,64135,657626,492583,106431,19116,1012466,211030,494815,1037114,963254,528872,125397,698586,662734,888556,760402,398471,918644,48763,128872,676736,716371,254931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]