SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541003 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541003 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61822,599033,631947,70846,322879,659093,804887,5846,580207,520518,632961,688427,301220,839334,165401,421649,108903,727055,383859,906909,673336,401174,130465,407536,280127,918171,342886,516352,817805,587875,382071,564660,696633,758947,1015761,251848,96360,217404,669759,408968,510390,176055,920385,598440,302110,241039,67165,854536,435181,689021,43967,938658,432937,771814,517631,600355,471476,803423,394416,596916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]