SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519712 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519712 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576331,13281,523459,123531,376610,925432,356406,370398,553181,16246,722253,1008504,88539,705617,257914,649007,590588,102945,682973,24215,690665,243026,507042,85823,233622,568311,79094,184542,283262,92874,968137,687744,214224,1012157,119794,71099,555421,598432,296308,230354,1010178,731722,397845,270380,830225,65398,570820,601012,194753,745660,247471,771727,438001,138117,60994,309753,125217,445308,905550,243942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]