SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 945692 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 945692 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773710,697898,831632,797609,390666,486214,1027602,986011,66621,1038663,100395,200668,919055,300373,313071,285170,893721,552796,673761,519790,18879,169544,387501,448788,875888,488144,824116,462013,804677,232321,450365,601010,479773,871648,817755,757046,192513,644442,275238,786486,471528,321553,476100,204345,255284,66483,358217,642895,1027509,899915,556157,85165,167803,684354,203732,472250,29938,137462,915747,853744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 945692 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 945692 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]