SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50834 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50834 [ RunTime:0.003535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210003,78227,1019914,45509,312243,566559,863262,963603,712349,337950,406363,287146,837849,894342,749868,105334,845232,591216,1037026,496790,56431,9716,940985,262924,419592,673845,427885,885468,962198,994643,1046127,1047366,989030,883683,151160,277677,432835,948250,191367,1000707,1033223,80073,470533,144932,494241,134187,595892,74665,283504,524907,935685,510589,802451,838087,166364,962600,931493,559957,261496,670203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000800s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]