SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 902843 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 902843 [ RunTime:0.002066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280795,93968,967426,90499,748927,449053,123370,265407,992390,145287,733599,1034010,142556,954973,524327,807607,1016554,666449,196202,133851,368216,915330,527573,126514,1041911,29434,41607,456464,145417,3881,758318,1013194,39213,992878,324439,318657,939951,610952,184188,424951,688919,801584,16553,726762,187491,378733,38589,756125,641006,790803,426894,1016659,97048,335853,1014878,26606,880825,686105,951627,336636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 902843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 902843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]