SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442217 LIMIT 1 [ RunTime:0.000559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442217 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017406,1517,114234,1005930,275143,230059,237004,977116,650235,122570,1020556,83683,846134,820748,819119,60902,156327,614502,163390,658608,615112,134539,196549,406475,300504,694625,497352,810198,813700,181841,1000139,357589,94565,805900,703378,565026,391082,509289,703509,1032531,1048785,602204,985199,556449,885566,436008,71265,205458,164693,571290,295939,1002365,483249,643518,280234,911651,965223,685427,357761,33104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]