SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508680 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508680 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733194,336933,590752,118540,480969,258727,582170,154002,340422,205305,598084,1046300,473238,421183,328273,850093,141386,800633,642298,982072,123846,508985,147839,221999,254154,149689,890985,707936,371185,848674,688254,960054,468453,418461,792920,803034,235136,1043884,1023086,329261,621382,582026,900073,861024,133356,663379,746829,963450,772472,564696,969734,682124,418083,537059,460294,731049,536483,643510,929178,167516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]