SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806771 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806771 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500273,26953,912395,443680,353996,342010,45225,857577,1045324,656889,763283,343022,437652,960835,555174,1024779,748472,960756,765935,537545,886475,244476,419033,647646,87735,1018601,783251,85995,97157,264700,974339,619129,493637,760819,762080,69473,571600,915188,638025,574988,1017502,958631,938856,153705,410767,828007,531595,369494,832421,327917,618753,213136,905112,326733,945927,336745,767053,828040,906276,204699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]